EMT Practice Test

1. Question Content...

---

Question1: Which of the following are required to monitor SAP HANA in SAP Solution Manager?
There are 2 correct answers to this question.
Response:

Question2: Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit?
There are 3 correct answers to this question.
Response:

Question3: Which SAP Hana command line tools do you use during the zero downtime maintenance process?
There are 2 correct answers to this question
Response:

Question4: Which of the following authentication methods does SAP HANA support for http(s) access?
There are 2 correct answers to this question.
Response:

Question5: Trace files are used to troubleshoot problems in the SAP HANA database, which of the following Trace types helps to generate Trace files through its activation?
There are 3 correct answers to this question
Response:

Question6: Which parameters do you change to configure the trace file rotation?
There are 2 correct answers to this question.
Response:

Question7: Which tool do you use to update the SAP that is installed on your Windows workstation
Please choose the correct answer.
Response:

Question8: What connection type does the SAP Hana direct Extractor connection (DXC) used to transfer data to SAP Hana?
Please choose the correct answer.
Response:

Question9: When SAP Hana is not fully started or it is stopped which service does the SAP Hana
Studio use to collect information about the database status
Please choose the correct answer.
Response:

Question10: When you try to create a delivery unit in the SAP Hana studio you receive an error message that the delivery unit CANNOT be created
How do you solve this problem?
Please choose the correct answer.
Response:

Question11: Which system privilege do you need to stop and start an SAP HANA database
Please choose the correct answer.
Response:

Question12: What information is shown on the overview tab of the administration console in the SAP
Hana studio?
There are 3 correct answers to this question
Response:

Question13: You need to read data from and write data to the Microsoft SQL server 2012 database using SAP Hana system.
You do not need to store the data in SAP Hana.
Which date of provision method do you use?
Please choose the correct answer.
Response:

Question14: You need to replicate data from an SAP ERP production system to SAP HANA.
Where does SAP recommend that you install the productive SAP Landscape
Transformation (SLT) instance?
Please choose the correct answer.
Response:

Question15: You plan to migrate a non-SAP database to SAP HANA using the Database Migration
Option of the Software Update Manager SP16. Which URL should you use?
Please choose the correct answer.
Response:

Question16: Which of the following are required to enable SAP HANA high availability?
There are 2 correct answers to this question.
Response:

Question17: Which features can you enable during the installation of the SAP Hana studio?
There are 2 correct answer to this question
Response:

Question18: Which view displays the current SAP HANA Support Package level?
Please choose the correct answer.
Response:

Question19: Which of the following views allows an administrator to identify all the authorizations assigned to a user?
Please choose the correct answer.
Response:

Question20: Which of the following are advantages of using the SAP CO-PA accelerator?
There are 2 correct answers to this question.
Response:

Question21: You are planning a batch installation for a scale-out system. Which settings do you need to make in the configuration file?
There are 2 correct answers to this question.
Response:

Question22: A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in SAP HANA to achieve this requirement?
Please choose the correct answer.
Response:

Question23: For one-step logon to the system on the PARMA host with instance number 01 as database user MONA with the password RED, which of the following command helps?
Please choose the correct answer.
Response:

Question24: Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role to other users?
Please choose the correct answer.
Response:

Question25: What are the characteristics of a design-time role?
There are 3 correct answers to this question
Response:

Question26: What are the recommended ways to perform a database backup?
There are 2 correct answers to this question.
Response:

Question27: What can you do to rename a SAP Hana system running with SPS 09?
Please choose the correct answer.
Response:

Question28: Which technologies use trigger-based replication?
There are 2 correct answers to this question.
Response:

Question29: What privileges can you manage with the SAP HANA Live authorization assistant?
There are 2 correct answers to this question.
Response:

Question30: What is the correct communication data flow between diagnostics in SAP Solution Manager and SAP HANA in the monitor scenario?
Please choose the correct answer.
Response:

Question31: You are investigating a problem with the SAP Hana database. You opened a customer message with SAP support.
SAP support asks you to provide last trace information from the SAP Hana instance. How do you gather this information?
There are 2 correct answers to this question
Response:

Question32: Which component is installed on each node when you install an SAP HANA scale-out systems?
Please choose the correct answer.
Response:

Question33: When you try to stop SAP HANA using the sapcontrol command, you receive the error messagE. "Command not found". What is the reason for the error?
Please choose the correct answer.
Response:

Question34: You deleted billions of records from several tables in the SAP Hana database. However. NO additional free space is gained in the file system for the data volume.
What is the reason?
Please choose the correct answer.
Response:

Question35: By default all authentication mechanisms are enabled, but it is possible and recommended to disable those that are not used in your environment. Which of the following methods helps you to change default parameter?
Please choose the correct answer.
Response:

Question36: In SAP HANA, what is the recommended memory size you must reserve for dynamic objects?
Please choose the correct answer.
Response:

Question37: In the SAP HANA studio, in which tab can you find information about the performance of queries?
Please choose the correct answer.
Response:

Question38: You are migrating an SAP ERP system to SAP Hana using the software update manager (SUM) with the database migration option (DMO).
What happens during the downtime phase?
Please choose the correct answer.
Response:

Question39: Using SAP Landscape Transformation (SLT), you are replicating in real-time an SAP ERP system (source system) into an SAP HANA system.
How can you check whether the source system and SLT are synchronized?
There are 2 correct answers to this question.
Response:

Question40: When does SAP recommend that you execute the first system backup?
Please choose the correct answer.
Response:

Question41: You want to update a productive SAP HANA system to the next support package stack
(SPS). What are the prerequisites?
There are 3 correct answers to this question.
Response:

Question42: What does the save point process in SAP HANA do?
Please choose the correct answer.
Response:

Question43: The SAP LT trigger-based approach uses a log table to record all relevant changes. Where is this log table stored?
Please choose the correct answer.
Response:

Question44: Which steps are combined in the software update manager database migration option
(DMO) procedure?
There are 2 correct answers to this question
Response:

Question45: To which roles must you be assigned in the SAP HANA cockpit to plan SAP HANA backups?
There are 2 correct answers to this question.
Response:

Question46: Which of the following techniques would you use to upgrade an SAP Hana system and keep the downtime to a minimum?
Please choose the correct answer.
Response:

Question47: In your SAP Hana database, The Automatic log backup is enabled and the parameter log_backup_timeout_s set to 0.
When a log backups still triggered?
There are 2 correct answers to this question
Response:

Question48: You want to analyze the root cause of a query that is performing poorly What does SAP recommended that you used in the SAP Hana studio?
Please choose the correct answer.
Response:

Question49: Which components do you need before installing and SAP lumira server?
There are 2 correct answers to this question
Response:

Question50: What software are you allowed to install on the SAP Hana appliance?
There are 2 correct answers to this question
Response:

Question51: During encryption key management, SAP HANA generates unique root keys on installation.
Which of the following root keys can be changed?
There are 2 correct answers to this question
Response:

Question52: Which operating system commands show the SAP HANA processes?
There are 2 correct answers to this question.
Response:

Question53: You have to load data in real time from external systems into SAP HANA,. Which Data
Provisioning tools can you use?
There are 3 correct answers to this question.
Response:

Question54: Which of the following tools can you use to create and manage SAP HANA database users?
There are 2 correct answers to this question.
Response:

Question55: You are replicating data in real-time from a source system to SAP HANA using System
Landscape Transformation (SLT).
The source system had to be restored using a point-in-time recovery to an earlier point in time. The systems are now out of sync.
How can you synchronize the systems again?
Please choose the correct answer.
Response:

Question56: When the diagnose tab will open in SAP HANA administrator overview?
There are 2 correct answers to this question.
Response:

Question57: Which monitoring view provides information on the analytic privileges that apply to a view and to authorized users?
Please choose the correct answer.
Response:

Question58: What happens when an SAP Hana system is restarted?
There are 2 correct answers to this question
Response:

Question59: Application users report that a query sometimes runs much slower than usual. You suspect that the high system load is slowing down the query execution
Where can you review the overall system workload when a query is executed?
There are 2 correct answers to this question
Response:

Question60: Where in the SAP HANA studio can you change the path of the backup folder?
There are 2 correct answers to this question.
Response: